Tabela AuthorisationSigns

Definicja tabeli AuthorisationSigns

Name

AuthorisationSigns

Code

AuthorisationSigns

Comment

Tabela zawiera podpisy i definicje wymaganego podpisu pod regula autoryzacji.


Lista kolumn tabeli AuthorisationSigns

Name

Code

AuthorisationSignID

AuthorisationSignID

UserTypeID

UserTypeID

PersonID

PersonID

AuthorisationRuleID

AuthorisationRuleID

Signed

Signed

TableName

TableName

PKeyID

PKeyID

InsertingPerson

InsertingPerson

InsertDT

InsertDT

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

StartDT

StartDT


Kolumna AuthorisationSignID tabeli AuthorisationSigns

Definicja kolumny AuthorisationSignID tabeli AuthorisationSigns

Name

AuthorisationSignID

Code

AuthorisationSignID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UserTypeID tabeli AuthorisationSigns

Definicja kolumny UserTypeID tabeli AuthorisationSigns

Name

UserTypeID

Code

UserTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli AuthorisationSigns

Definicja kolumny PersonID tabeli AuthorisationSigns

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AuthorisationRuleID tabeli AuthorisationSigns

Definicja kolumny AuthorisationRuleID tabeli AuthorisationSigns

Name

AuthorisationRuleID

Code

AuthorisationRuleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID reguly autoryzacji


Kolumna Signed tabeli AuthorisationSigns

Definicja kolumny Signed tabeli AuthorisationSigns

Name

Signed

Code

Signed

Data Type

NUMBER(5)

Mandatory

Yes

Comment

1 - podpis zlozony / 0 - podpis wymagany


Kolumna TableName tabeli AuthorisationSigns

Definicja kolumny TableName tabeli AuthorisationSigns

Name

TableName

Code

TableName

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

Nazwa tabeli przechowujacej autoryzowany obiekt np. FormInstance, DescriptiveData


Kolumna PKeyID tabeli AuthorisationSigns

Definicja kolumny PKeyID tabeli AuthorisationSigns

Name

PKeyID

Code

PKeyID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Identyfikator autoryzowanego obiektu np. FormInstanceID, DescriptiveDataID


Kolumna InsertingPerson tabeli AuthorisationSigns

Definicja kolumny InsertingPerson tabeli AuthorisationSigns

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDT tabeli AuthorisationSigns

Definicja kolumny InsertDT tabeli AuthorisationSigns

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedDT tabeli AuthorisationSigns

Definicja kolumny LastModifiedDT tabeli AuthorisationSigns

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

Yes

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli AuthorisationSigns

Definicja kolumny LastModifiedPerson tabeli AuthorisationSigns

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli AuthorisationSigns

Definicja kolumny StartDT tabeli AuthorisationSigns

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Lista kluczy tabeli AuthorisationSigns

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli AuthorisationSigns

Definicja klucza Identifier_1 tabeli AuthorisationSigns

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment